Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Defining native stored procedures to the Progress 4GL

The first time you run a stored procedure, the data-source management system creates an execution plan for it and stores the plan in the database. The next time you run the stored procedure, it runs the precompiled procedure, assuming it is still cached in the database. This makes access to the database quicker and more efficient than when you access it with new queries each time.

The DataServer allows you to use Progress 4GL to run ORACLE stored procedures. All pre-defined stored procedures initiated on behalf of the ORACLE are executed from within Progress 4GL, using the RUN STORED-PROCEDURE statement. You define specific 4GL language elements to the RUN STORED-PROCEDURE statement to match the profile or signature of your native stored procedure. You can also provide additional 4GL statements subsequent to the RUN STORED-PROCEDURE statement to handle result sets from stored procedures.